EDA

Dataset statistics

Number of variables	12
Number of observations	2774
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	281.7 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`avg_basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_days_orders` is highly overall correlated with `frequency`	High correlation
`avg_products_order` is highly overall correlated with `avg_ticket` and 1 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_products_order`	High correlation
`frequency` is highly overall correlated with `avg_days_orders`	High correlation
`gross_revenue` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`orders` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`total_items` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`total_products` is highly overall correlated with `avg_products_order` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 51.90076808)	Skewed
`frequency` is highly skewed (γ1 = 47.41381733)	Skewed
`items_returned` is highly skewed (γ1 = 50.10197766)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.87225707)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 34 (1.2%) zeros	Zeros
`items_returned` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2024-05-22 11:08:59.515162
Analysis finished	2024-05-22 11:09:13.535792
Duration	14.02 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2774
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.7

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.65
Q1	13815.25
median	15242.5
Q3	16779.75
95-th percentile	17950.35
Maximum	18287
Range	5940
Interquartile range (IQR)	2964.5

Descriptive statistics

Standard deviation	1714.9849
Coefficient of variation (CV)	0.11219538
Kurtosis	-1.2069151
Mean	15285.7
Median Absolute Deviation (MAD)	1483.5
Skewness	0.015990788
Sum	42402531
Variance	2941173.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15060	1	< 0.1%
17850	1	< 0.1%
13047	1	< 0.1%
12583	1	< 0.1%
13748	1	< 0.1%
15100	1	< 0.1%
15291	1	< 0.1%
14688	1	< 0.1%
17809	1	< 0.1%
15311	1	< 0.1%
Other values (2764)	2764	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2760
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2904.6492

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.557
Q1	628.195
median	1170.87
Q3	2423.86
95-th percentile	7579.4915
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.665

Descriptive statistics

Standard deviation	10927.083
Coefficient of variation (CV)	3.7619287
Kurtosis	331.96378
Mean	2904.6492
Median Absolute Deviation (MAD)	690.475
Skewness	16.261241
Sum	8057496.7
Variance	1.1940114 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
178.96	2	0.1%
331	2	0.1%
2053.02	2	0.1%
745.06	2	0.1%
889.93	2	0.1%
734.94	2	0.1%
1314.45	2	0.1%
598.2	2	0.1%
731.9	2	0.1%
379.65	2	0.1%
Other values (2750)	2754	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.627974

Minimum	0
Maximum	372
Zeros	34
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.419023
Coefficient of variation (CV)	1.2082195
Kurtosis	3.4321191
Mean	56.627974
Median Absolute Deviation (MAD)	23.5
Skewness	1.8983643
Sum	157086
Variance	4681.1627
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
3	85	3.1%
2	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2027	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

orders
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0529921

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.071603
Coefficient of variation (CV)	1.4986973
Kurtosis	183.94516
Mean	6.0529921
Median Absolute Deviation (MAD)	2
Skewness	10.624664
Sum	16791
Variance	82.293981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

total_items
Real number (ℝ)

HIGH CORRELATION

Distinct	1632
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1697.8205

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330.25
median	699.5
Q3	1478
95-th percentile	4645.5
Maximum	196844
Range	196842
Interquartile range (IQR)	1147.75

Descriptive statistics

Standard deviation	6074.4301
Coefficient of variation (CV)	3.5777812
Kurtosis	438.72722
Mean	1697.8205
Median Absolute Deviation (MAD)	449
Skewness	17.339197
Sum	4709754
Variance	36898701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
516	7	0.3%
394	7	0.3%
200	7	0.3%
1200	7	0.3%
272	7	0.3%
300	7	0.3%
219	7	0.3%
Other values (1622)	2698	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

total_products
Real number (ℝ)

HIGH CORRELATION

Distinct	468
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.72314

Minimum	2
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	400.05
Maximum	7837
Range	7835
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.72934
Coefficient of variation (CV)	2.140939
Kurtosis	336.80085
Mean	129.72314
Median Absolute Deviation (MAD)	45
Skewness	15.347204
Sum	359852
Variance	77133.584
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	40	1.4%
35	34	1.2%
26	30	1.1%
27	30	1.1%
29	28	1.0%
33	27	1.0%
31	27	1.0%
15	27	1.0%
20	26	0.9%
42	26	0.9%
Other values (458)	2479	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	11	0.4%
3	13	0.5%
4	16	0.6%
5	16	0.6%
6	24	0.9%
7	14	0.5%
8	13	0.5%
9	20	0.7%
10	18	0.6%
11	23	0.8%

Value	Count	Frequency (%)
7837	1	< 0.1%
5670	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1919
Distinct (%)	69.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.339156

Minimum	2.15
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2.15
5-th percentile	4.85
Q1	12.43
median	17.945
Q3	25.075
95-th percentile	88.4275
Maximum	56157.5
Range	56155.35
Interquartile range (IQR)	12.645

Descriptive statistics

Standard deviation	1071.0491
Coefficient of variation (CV)	20.46363
Kurtosis	2718.3215
Mean	52.339156
Median Absolute Deviation (MAD)	6.335
Skewness	51.900768
Sum	145188.82
Variance	1147146.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.49	7	0.3%
19.06	6	0.2%
16.82	6	0.2%
17.66	6	0.2%
16.92	5	0.2%
10	5	0.2%
17.13	5	0.2%
17.81	5	0.2%
19.44	5	0.2%
17.71	5	0.2%
Other values (1909)	2719	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.15	1	< 0.1%
2.43	1	< 0.1%
2.46	1	< 0.1%
2.51	1	< 0.1%
2.52	1	< 0.1%
2.65	1	< 0.1%
2.66	1	< 0.1%
2.71	1	< 0.1%
2.76	1	< 0.1%
2.77	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.99	1	< 0.1%
872.13	1	< 0.1%
841.02	1	< 0.1%
651.17	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_days_orders
Real number (ℝ)

HIGH CORRELATION

Distinct	1155
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.801889

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.241667
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.758333

Descriptive statistics

Standard deviation	66.515011
Coefficient of variation (CV)	0.84407889
Kurtosis	3.6744362
Mean	78.801889
Median Absolute Deviation (MAD)	30
Skewness	1.8283611
Sum	218596.44
Variance	4424.2467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
91	16	0.6%
31	16	0.6%
49	16	0.6%
42	15	0.5%
35	15	0.5%
21	15	0.5%
14	14	0.5%
Other values (1145)	2611	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1228
Distinct (%)	44.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.061816117

Minimum	0.0054644809
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.0054644809
5-th percentile	0.0087719298
Q1	0.015873016
median	0.024516482
Q3	0.042135511
95-th percentile	0.11795995
Maximum	34
Range	33.994536
Interquartile range (IQR)	0.026262495

Descriptive statistics

Standard deviation	0.66943924
Coefficient of variation (CV)	10.829526
Kurtosis	2387.1027
Mean	0.061816117
Median Absolute Deviation (MAD)	0.010780219
Skewness	47.413817
Sum	171.47791
Variance	0.4481489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.07142857143	16	0.6%
0.04761904762	15	0.5%
0.01587301587	14	0.5%
0.0303030303	14	0.5%
0.02857142857	14	0.5%
0.02380952381	13	0.5%
0.06451612903	13	0.5%
0.1428571429	13	0.5%
0.025	12	0.4%
0.1176470588	12	0.4%
Other values (1218)	2638	95.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005602240896	2	0.1%
0.005617977528	1	< 0.1%
0.005633802817	2	0.1%
0.005681818182	1	< 0.1%
0.005698005698	2	0.1%
0.005714285714	3	0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	6	0.2%
1.5	1	< 0.1%
1.333333333	2	0.1%
1	4	0.1%
0.6666666667	3	0.1%
0.5522788204	1	< 0.1%
0.5349462366	1	< 0.1%

items_returned
Real number (ℝ)

SKEWED ZEROS

Distinct	205
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.158976

Minimum	0
Maximum	80995
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	98
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1564.3935
Coefficient of variation (CV)	24.383081
Kurtosis	2586.2541
Mean	64.158976
Median Absolute Deviation (MAD)	0
Skewness	50.101978
Sum	177977
Variance	2447327.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
7	38	1.4%
Other values (195)	653	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1932
Distinct (%)	69.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	245.46514

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.33333
median	172
Q3	278.17381
95-th percentile	585.55
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	174.84048

Descriptive statistics

Standard deviation	808.02308
Coefficient of variation (CV)	3.2918039
Kurtosis	2224.0987
Mean	245.46514
Median Absolute Deviation (MAD)	81
Skewness	44.872257
Sum	680920.29
Variance	652901.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
73	7	0.3%
136	7	0.3%
208	7	0.3%
197	7	0.3%
82	7	0.3%
105	7	0.3%
Other values (1922)	2696	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%

avg_products_order
Real number (ℝ)

HIGH CORRELATION

Distinct	1003
Distinct (%)	36.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.122355

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.5
Q1	10.127083
median	17.296703
Q3	28.083333
95-th percentile	56.64697
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.95625

Descriptive statistics

Standard deviation	18.868378
Coefficient of variation (CV)	0.85290999
Kurtosis	24.16784
Mean	22.122355
Median Absolute Deviation (MAD)	8.2967033
Skewness	3.1572707
Sum	61367.414
Variance	356.01568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	44	1.6%
14	31	1.1%
11	29	1.0%
9	26	0.9%
1	26	0.9%
10.5	25	0.9%
7.5	25	0.9%
17.5	25	0.9%
18	24	0.9%
9.5	24	0.9%
Other values (993)	2495	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26	0.9%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	21	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
203.5	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%
110.3333333	1	< 0.1%
109.6666667	2	0.1%

Auto

Heatmap
Table

	avg_basket_size	avg_days_orders	avg_products_order	avg_ticket	customer_id	frequency	gross_revenue	items_returned	orders	recency_days	total_items	total_products
avg_basket_size	1.000	-0.042	0.431	0.199	-0.120	0.024	0.602	0.215	0.125	-0.104	0.759	0.402
avg_days_orders	-0.042	1.000	0.061	-0.079	-0.012	-0.951	-0.366	-0.214	-0.477	0.223	-0.342	-0.301
avg_products_order	0.431	0.061	1.000	-0.627	0.006	-0.070	0.281	0.026	0.017	-0.104	0.311	0.721
avg_ticket	0.199	-0.079	-0.627	1.000	-0.141	0.080	0.274	0.189	0.090	0.034	0.196	-0.382
customer_id	-0.120	-0.012	0.006	-0.141	1.000	0.013	-0.085	-0.058	0.013	0.013	-0.078	0.012
frequency	0.024	-0.951	-0.070	0.080	0.013	1.000	0.254	0.173	0.317	-0.124	0.236	0.199
gross_revenue	0.602	-0.366	0.281	0.274	-0.085	0.254	1.000	0.462	0.762	-0.374	0.922	0.722
items_returned	0.215	-0.214	0.026	0.189	-0.058	0.173	0.462	1.000	0.425	-0.187	0.427	0.328
orders	0.125	-0.477	0.017	0.090	0.013	0.317	0.762	0.425	1.000	-0.447	0.703	0.659
recency_days	-0.104	0.223	-0.104	0.034	0.013	-0.124	-0.374	-0.187	-0.447	1.000	-0.366	-0.391
total_items	0.759	-0.342	0.311	0.196	-0.078	0.236	0.922	0.427	0.703	-0.366	1.000	0.707
total_products	0.402	-0.301	0.721	-0.382	0.012	0.199	0.722	0.328	0.659	-0.391	0.707	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	orders	total_items	total_products	avg_ticket	avg_days_orders	frequency	items_returned	avg_basket_size	avg_products_order
0	17850	5391.21	372.0	34.0	1733.0	297.0	18.15	1.000000	34.000000	40.0	50.970588	8.735294
1	13047	3232.59	56.0	9.0	1390.0	171.0	18.90	52.833333	0.028391	35.0	154.444444	19.000000
2	12583	6705.38	2.0	15.0	5028.0	232.0	28.90	26.500000	0.040431	50.0	335.200000	15.466667
3	13748	948.25	95.0	5.0	439.0	28.0	33.87	92.666667	0.017986	0.0	87.800000	5.600000
4	15100	876.00	333.0	3.0	80.0	3.0	292.00	20.000000	0.075000	22.0	26.666667	1.000000
5	15291	4623.30	25.0	14.0	2102.0	102.0	45.33	26.769231	0.040230	29.0	150.142857	7.285714
6	14688	5630.87	7.0	21.0	3621.0	327.0	17.22	19.263158	0.057377	399.0	172.428571	15.571429
7	17809	5411.91	16.0	12.0	2057.0	61.0	88.72	39.666667	0.033613	41.0	171.416667	5.083333
8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.54	4.191011	0.243968	474.0	419.714286	26.142857
9	16098	2005.63	87.0	7.0	613.0	67.0	29.93	47.666667	0.024476	0.0	87.571429	9.571429

	customer_id	gross_revenue	recency_days	orders	total_items	total_products	avg_ticket	avg_days_orders	frequency	items_returned	avg_basket_size	avg_products_order
5611	17290	525.24	3.0	2.0	404.0	102.0	5.15	13.0	0.153846	0.0	202.000000	51.0
5620	14785	77.40	10.0	2.0	84.0	3.0	25.80	5.0	0.400000	0.0	42.000000	1.5
5621	17254	272.44	4.0	2.0	252.0	112.0	2.43	11.0	0.181818	0.0	126.000000	56.0
5637	17232	421.52	2.0	2.0	203.0	36.0	11.71	12.0	0.166667	0.0	101.500000	18.0
5638	17468	137.00	10.0	2.0	116.0	5.0	27.40	4.0	0.500000	0.0	58.000000	2.5
5649	13596	697.04	5.0	2.0	406.0	166.0	4.20	7.0	0.285714	0.0	203.000000	83.0
5655	14893	1237.85	9.0	2.0	799.0	73.0	16.96	2.0	1.000000	0.0	399.500000	36.5
5680	14126	706.13	7.0	3.0	508.0	15.0	47.08	3.0	1.000000	50.0	169.333333	5.0
5686	13521	1092.39	1.0	3.0	733.0	435.0	2.51	4.5	0.333333	0.0	244.333333	145.0
5696	15060	301.84	8.0	4.0	262.0	120.0	2.52	1.0	4.000000	0.0	65.500000	30.0

Overview

Variables

Interactions

Correlations

Missing values

Sample